home *** CD-ROM | disk | FTP | other *** search
/ PC World 2008 February (DVD) / PCWorld_2008-02_DVD.iso / v cisle / PHP / PHP.exe / EasyPHP-2.0b1-setup.exe / {app} / sqlitemanager / include / defined.inc.php < prev    next >
Encoding:
PHP Script  |  2006-04-18  |  8.4 KB  |  328 lines
  1. <?php
  2. /**
  3. * Web based SQLite management
  4. * Some defines
  5. * @package SQLiteManager
  6. * @author FrΘdΘric HENNINOT
  7. * @version $Id: defined.inc.php,v 1.89 2006/04/17 18:58:20 freddy78 Exp $ $Revision: 1.89 $
  8. */
  9. include_once "./include/user_defined.inc.php";
  10.  
  11. $baseDir = str_replace('\\','/',dirname(__FILE__));
  12.  
  13. if(!defined('INCLUDE_LIB')) define ('INCLUDE_LIB',$baseDir.'/');
  14.  
  15. define('SQLiteManagerVersion', '1.2.0');
  16.  
  17. if (!defined('DEBUG') && strpos(SQLiteManagerVersion,'CVS')) {
  18.     define('DEBUG',true);
  19. } else if(!defined('DEBUG')) {
  20.     define('DEBUG', false);
  21. }
  22. if (DEBUG) {
  23.   if (function_exists('apd_set_pprof_trace')) apd_set_pprof_trace();
  24. }
  25.  
  26. // Default Folder for Uploaded file Database
  27. if(!defined('DEFAULT_DB_PATH')) {
  28.   define('DEFAULT_DB_PATH', substr($baseDir, 0, strlen($baseDir) - 7));
  29. }
  30.  
  31. if(!defined('WITH_AUTH')) define('WITH_AUTH', false);
  32.  
  33. if(!defined('ALLOW_CHANGE_PASSWD')) define('ALLOW_CHANGE_PASSWD', true);
  34.  
  35. if(!defined('ALLOW_EXEC_PLUGIN')) define('ALLOW_EXEC_PLUGIN', false);
  36.  
  37. $availableLangue = array(    1=>'french', 2=>'english', 3=>'polish',
  38.                 4=>'german', 5=>'japanese', 6=>'italian',
  39.                 7=>'croatian', 8=>'brazilian_portuguese', 9=>'dutch',
  40.                 10=>'spanish', 11=>'danish', 12=>'traditional_chinese',
  41.                 13=>'simplified_chinese');
  42.  
  43. $availableTheme = array("default", "green", "PMA", "jall");
  44.  
  45. $dbItems = array('Table', 'View', 'Trigger', 'Function');
  46.  
  47. if(isset($_POST['Theme'])) {
  48.     $localTheme = $_POST['Theme'];
  49.     setcookie('SQLiteManager_currentTheme',$_POST['Theme'],1719241200,'/');
  50.     $_COOKIE['SQLiteManager_currentTheme'] = $_POST['Theme'];
  51.     echo "<script type=\"text/javascript\">parent.location='index.php';</script>";
  52. } elseif(isset($_COOKIE['SQLiteManager_currentTheme'])) {
  53.     $localtheme = $_COOKIE['SQLiteManager_currentTheme'];
  54. } else {
  55.     $localtheme = 'green';
  56. }
  57.  
  58. // set cookie for FullText
  59. if(isset($_GET['fullText'])) {
  60.     $allFullText = $_GET['fullText'];
  61.     setcookie('SQLiteManager_fullText',$_GET['fullText'],1719241200,'/');
  62.     $_COOKIE['SQLiteManager_fullText'] = $_GET['fullText'];
  63. } elseif(isset($_COOKIE['SQLiteManager_fullText'])) {
  64.     $allFullText = $_COOKIE['SQLiteManager_fullText'];
  65. } else {
  66.     $allFullText = true;
  67. }
  68.  
  69. // set cookie for see HTML
  70. if(isset($_GET['HTMLon'])) {
  71.     $allHTML = $_GET['HTMLon'];
  72.     setcookie('SQLiteManager_HTMLon',$_GET['HTMLon'],1719241200,'/');
  73.     $_COOKIE['SQLiteManager_HTMLon'] = $_GET['HTMLon'];
  74. } elseif(isset($_COOKIE['SQLiteManager_HTMLon'])) {
  75.     $allHTML = $_COOKIE['SQLiteManager_HTMLon'];
  76. } else {
  77.     $allHTML = true;
  78. }
  79.  
  80. /**
  81. * image to see 'ASC' order
  82. */
  83. define('IMG_ASC',     ((file_exists('./theme/'.$localtheme.'/pics/down.gif'))? './theme/'.$localtheme.'/pics/down.gif' : './theme/default/pics/down.gif' ));/**
  84. * image to see 'DESC' order
  85. */
  86. define('IMG_DESC',     ((file_exists('./theme/'.$localtheme.'/pics/up.gif'))? './theme/'.$localtheme.'/pics/up.gif' : './theme/default/pics/up.gif' ));/**
  87. * Image for paginate navigation, you can remove it.
  88. */
  89. define('NAV_TOP',     ((file_exists('./theme/'.$localtheme.'/pics/top.gif'))? './theme/'.$localtheme.'/pics/top.gif' : './theme/default/pics/top.gif' ));/**
  90. * Image for paginate navigation, you can remove it.
  91. */
  92. define('NAV_PREC',     ((file_exists('./theme/'.$localtheme.'/pics/left.gif'))? './theme/'.$localtheme.'/pics/left.gif' : './theme/default/pics/left.gif' ));/**
  93. * Image for paginate navigation, you can remove it.
  94. */
  95. define('NAV_SUIV',     ((file_exists('./theme/'.$localtheme.'/pics/right.gif'))? './theme/'.$localtheme.'/pics/right.gif' : './theme/default/pics/right.gif' ));/**
  96. * Image for paginate navigation, you can remove it.
  97. */
  98. define('NAV_END',     ((file_exists('./theme/'.$localtheme.'/pics/end.gif'))? './theme/'.$localtheme.'/pics/end.gif' : './theme/default/pics/end.gif' ));/**
  99. * Separator for navigation bar.
  100. */
  101. define('NAV_SEP',     ' - ');
  102. /**
  103. * Number of Link in the navigation bar.
  104. */
  105. if(!defined('NAV_NBLINK')) define('NAV_NBLINK', 10);
  106.  
  107.  
  108. define('DEMO_MODE', false);
  109.  
  110. if(!defined('ADVANCED_EDITOR')) define('ADVANCED_EDITOR', true);
  111. if(ADVANCED_EDITOR && !defined('SPAW_PATH')) {
  112.     $base = str_replace("/include", "", $baseDir);
  113.     define('SPAW_PATH', $base.'/spaw/');
  114. }
  115.  
  116. if(!defined("SPAW_TOOLBAR_STYLE")) define("SPAW_TOOLBAR_STYLE", "sqlitemanager");
  117.  
  118. set_magic_quotes_runtime(0);
  119. if(DEBUG) {
  120.     error_reporting(E_ALL);
  121. } else {
  122.     error_reporting(E_ALL ^ E_NOTICE);
  123. }
  124.  
  125. if(!defined('LEFT_FRAME_WIDTH'))         define('LEFT_FRAME_WIDTH', 200);
  126. if(!defined('TEXTAREA_NB_COLS'))         define('TEXTAREA_NB_COLS', 65);
  127. if(!defined('TEXAREA_NB_ROWS'))            define('TEXAREA_NB_ROWS', 5);
  128. if(!defined('PARTIAL_TEXT_SIZE'))        define('PARTIAL_TEXT_SIZE', 20);
  129. if(!defined('DISPLAY_EMPTY_ITEM_LEFT'))    define('DISPLAY_EMPTY_ITEM_LEFT', true);
  130. if(!defined('BROWSE_NB_RECORD_PAGE'))    define('BROWSE_NB_RECORD_PAGE', 20);
  131. if(!defined('ALLOW_FULLSEARCH'))        define('ALLOW_FULLSEARCH', true);
  132. if(!defined('JSCALENDAR_USE'))            define('JSCALENDAR_USE', true);
  133. if(!defined('JSCALENDAR_PATH'))            define('JSCALENDAR_PATH', 'jscalendar/');
  134.  
  135. $SQLpunct = '.,;:=&()-+!<>';
  136.  
  137. $SQLoperator = array(
  138.                             'ABORT',
  139.                             'AFTER',
  140.                             'AND',
  141.                             'BEFORE',
  142.                             'BEGIN',
  143.                             'BETWEEN',
  144.                             'CASE',
  145.                             'CHECK',
  146.                             'COLLATE',
  147.                             'CONSTRAINT',
  148.                             'CASCADE',
  149.                             'CLUSTER',
  150.                             'CONFLICT',
  151.                             'DEFAULT',
  152.                             'DEFERRABLE',
  153.                             'DISTINCT',
  154.                             'DEFERRED',
  155.                             'DELIMITERS',
  156.                             'DESC',
  157.                             'EACH',
  158.                             'ELSE',
  159.                             'EXCEPT',
  160.                             'END',
  161.                             'FAIL',
  162.                             'FOR',
  163.                             'FOREIGN',
  164.                             'GLOB',
  165.                             'IN',
  166.                             'INTERSECT',
  167.                             'IS',
  168.                             'ISNULL',
  169.                             'IGNORE',
  170.                             'IMMEDIATE',
  171.                             'INITIALLY',
  172.                             'INSTEAD',
  173.                             'MATCH',
  174.                             'OF',
  175.                             'OFFSET',
  176.                             'RESTRICT',
  177.                             'ROW',
  178.                             'STATEMENT',
  179.                             'TEMP ALL',
  180.                             'LIKE',
  181.                             'NOT',
  182.                             'NOTNULL',
  183.                             'NULL',
  184.                             'OR',
  185.                             'PRIMARY',
  186.                             'REFERENCES',
  187.                             'THEN',
  188.                             'UNIQUE',
  189.                             'USING',
  190.                             'WHEN'
  191.                         );
  192.  
  193. $SQLKeyWordList = array(
  194.                             'AS',
  195.                             'ASC',
  196.                             'ATTACH',
  197.                             'BY',
  198.                             'COMMIT',
  199.                             'CREATE',
  200.                             'COPY',
  201.                             'CROSS',
  202.                             'DATABASE',
  203.                             'DELETE',
  204.                             'DROP',
  205.                             'DETACH',
  206.                             'EXPLAIN',
  207.                             'FROM',
  208.                             'FULL',
  209.                             'GROUP',
  210.                             'HAVING',
  211.                             'INDEX',
  212.                             'INSERT',
  213.                             'INTO',
  214.                             'INNER',
  215.                             'JOIN',
  216.                             'KEY',
  217.                             'LEFT',
  218.                             'LIMIT',
  219.                             'NATURAL',
  220.                             'OUTER',
  221.                             'PRAGMA',
  222.                             'RAISE',
  223.                             'REPLACE',
  224.                             'RIGHT',
  225.                             'ON',
  226.                             'ORDER',
  227.                             'ROLLBACK',
  228.                             'SELECT',
  229.                             'SET',
  230.                             'TABLE',
  231.                             'UNION',
  232.                             'UPDATE',
  233.                             'VALUES',
  234.                             'VACUUM',
  235.                             'VIEW',
  236.                             'WHERE',
  237.                             'TEMPORARY',
  238.                             'TRANSACTION',
  239.                             'TRIGGER'
  240.                         );
  241.  
  242. $SQLfunction    = array(
  243.                             'LENGTH',
  244.                             'LOWER',
  245.                             'UPPER',
  246.                             'SUBSTR',
  247.                             'SOUNDEX',
  248.                             'MD5',
  249.                             'NOW',
  250.                             'LAST_INSERT_ROWID',
  251.                             'RANDOM',
  252.                             'COUNT',
  253.                             'ABS',
  254.                             'AVG',
  255.                             'SUM',
  256.                             'MIN',
  257.                             'MAX',
  258.                             'ROUND'
  259.                         );
  260. $SQLiteType        = array(
  261.                             ''                =>    '',
  262.                             'VARCHAR'        =>    '',
  263.                             'TINYINT'        =>    '0',
  264.                             'INTEGER'        =>    '0',
  265.                             'INT'            =>    '0',
  266.                             'TEXT'            =>    '',
  267.                             'DATE'            =>    '0000-00-00',
  268.                             'SMALLINT'        =>    '0',
  269.                             'MEDIUMINT'        =>    '0',
  270.                             'BIGINT'        =>    '0',
  271.                             'FLOAT'            =>    '0.0',
  272.                             'DOUBLE'        =>    '0',
  273.                             'DECIMAL'        =>    '0.0',
  274.                             'DATETIME'        =>    '0000-00-00 00:00',
  275.                             'TIMESTAMP'        =>    '0',
  276.                             'TIME'            =>    '00:00',
  277.                             'YEAR'            =>    '0',
  278.                             'CHAR'            =>    '',
  279.                             'TINYBLOB'        =>    '',
  280.                             'TINYTEXT'        =>    '',
  281.                             'BLOB'            =>    '',
  282.                             'MEDIUMBLOB'    =>    '',
  283.                             'MEDIUMTEXT'    =>    '',
  284.                             'LONGBLOB'        =>    '',
  285.                             'LONGTEXT'        =>    '',
  286.                             'CLOB'            =>    '',
  287.                             'BOOLEAN'        =>    '',
  288.                         );
  289.  
  290. $SQLselect = array(        
  291.                             '<',
  292.                             '<=',
  293.                             '>',
  294.                             '>=',
  295.                             '=',
  296.                             '!=',
  297.                             'LIKE',
  298.                             'NOT LIKE',
  299.                             'GLOB',
  300.                             'NOT GLOB',
  301.                             'ISNULL',
  302.                             'NOTNULL',
  303.                             'fulltextsearch'
  304.                         );    
  305. $elementStartQuery = array(
  306.                             'ALTER',
  307.                             'ATTACH',
  308.                             'BEGIN',
  309.                             'COMMIT',
  310.                             'COPY',
  311.                             'CREATE',
  312.                             'DELETE',
  313.                             'DETACH',
  314.                             'DROP',
  315.                             'END',
  316.                             'EXPLAIN',
  317.                             'INSERT',
  318.                             'PRAGMA',
  319.                             'REINDEX',
  320.                             'REPLACE',
  321.                             'ROLLBACK',
  322.                             'SELECT',
  323.                             'UPDATE',
  324.                             'VACUUM' 
  325.                         );                    
  326.  
  327. ?>
  328.